How to: Base a combo box on a query.
Solution:
After creating a combo box, update the property sheet of the new combo box so the 'Row Source Type' is set to 'Field List' and the 'Row Source' is set to the desired query.
NOTE 1: The Developer Tool must be installed to use wizards.
NOTE 2: If the Database window is not active, activate the Database window.
1) Click the 'Forms' tab in the Database window.
Forms tab
2) Select the desired form from the list box. (The selected form is highlighted.)
3) Click 'Design'. (The selected form appears in the Form Design view.)
4) Make sure the 'Control Wizard' located on the Toolbox is NOT depressed.
5) Click 'Combo Box' on the Toolbox.
6) Click on the location within the form where the combo box is to appear. (The cursor appears as the Combo Box button.)
7) Open the 'Combo Box' property sheet:
a) Select the combo box. (Handles appear around the combo box.)
b) Select the 'View' menu and select 'Properties'. (The Combo box property box appears.)
8) Select 'Field List' in the 'Row Source Type' property box:
a) Click the 'Data' tab.
b) Click in the 'Row Source Type' property box. (A down arrow button appears to the right of the Row Source Type property box.)
c) Click on the down arrow. (A drop-down list appears.)
d) Select 'Field List' from the drop-down list.
9) Select the name of the query that has the fields to be displayed in the combo box, from the 'Row Source' property box:
a) Click in the ''Row Source' property box. (A down arrow button appears to the right of the 'Row Source Type' property box.)
b) Click on the down arrow. (A drop-down list appears.)
c) Select the desired query from the drop-down list box.
10) To close the property sheet, click the 'X' in the upper-right hand corner of the property sheet.
Click X button to close property sheet
NOTE: The properties will be saved only when the design view is saved.
